#!/bin/sh
echo "开始查询"
hive -e "select province_name,
                      city_name,
                      code_type,
                      sum(amt) as sum_amt
                      from dw00.dw_order_info group by province_name,city_name,code_type;"
echo $?
echo "查询完成"